CxTrsEditor Methods

The CxTrsEditor object contains the following methods:

Connect
Copy
Delete
Disconnect
Edit
Find
New
View

Connect

The Connect method connects the object to a service.

Syntax

Connect(DomainSiteService As String)

Parameters

Parameter	Required	Description
DomainSiteService	Yes	The [Domain]Site.Service to which to connect. The domain is optional. The service must be a valid one.

Remarks

Returns 0 if successful and a non-zero value if the connection failed.

Example

The following example connects the Client object to the CYGDEMO.<SVC> on domain 5410:

Copy

Connect

1
2
3
4
5
6
7
Sub

    Dim TrsEditor
    Set TrsEditor = CreateObject("CxEditors.CxTrsEditor")
    TrsEditor.Connect("[5410]CYGDEMO.TRS")

End Sub

Copy

The Copy method launches a New Table Entry dialog box initialized with the information in the specified record.

Syntax

Copy(QueueKey As String) As Integer

Parameters

Parameter	Required	Description
QueueKey	Yes	The database queue key of the record to copy.

Remarks

This method returns one of the following values:

	-1 or 0	An error occurred.
	1	OK button was pressed.
	2	Cancel button was pressed.

Example

The following example launches a Copy or New dialog box for the record "0000012345."

Copy

1
2
3
4
5
6
7
8
Sub Copy()

    Dim iRet
    iRet = <SvcClient>.Copy("0000012345")
 
    MsgBox iRet

End Sub

The following example launches a New Table Entry dialog box for entry "0" of table "COMSTATE."

Copy

1
2
3
4
5
6
7
8
9
Sub

    Dim iKey
    iKey = TrsEditor.Find("COMSTATE", "0")
    Dim iRet
    iRet= TrsEditor.Copy(iKey)
    MsgBox iRet

End Sub

Delete

The Delete method launches a Delete Entry dialog box initialized with the information in the specified record.

Syntax

Delete(QueueKey As String) As Integer

Parameters

Parameter	Required	Description
QueueKey	Yes	The database queue key of the record to delete.

Remarks

This method returns one of the following values:

	-1 or 0	An error occurred.
	1	OK button was pressed.
	2	Cancel button was pressed.

Example

The following example launches the specified Delete dialog box for record "0000012345":

Copy

Delete

1
2
3
4
5
6
7
8
Sub

    Dim iRet
    iRet = <SvcEditor>.Delete("0000012345")
 
    MsgBox iRet
    
End Sub

The following example launches a Delete Entry dialog box for entry "0" of table "COMSTATE."

Copy

Delete

1
2
3
4
5
6
7
8
9
10
Sub

    Dim iKey
    iKey = TrsEditor.Find("COMSTATE", "0")
    
    Dim iRet
    iRet= TrsEditor.Delete(iKey)
    MsgBox iRet

End Sub

Disconnect

The Disconnect method disconnects from the connected service.

Syntax

Disconnect() As Integer

Remarks

The Disconnect method returns 0 if successful and a non-zero value if the disconnect failed.

Example

The following example disconnects the Client object from the connected service, and pops a message box if it is unsuccessful:

Copy

Disconnect

1
2
3
4
5
6
7
8
9
10
11
Sub Svc.Disconnect()
 
    <SvcClient>.Disconnect()
    MsgBox "Service has disconnected."
    
    If <SvcClient>.Disconnect <> 0 
    Then
        MsgBox "Failed to disconnect."
    End If

End Sub

Edit

The Edit method launches an editor dialog box initialized with the information in the specified record.

Syntax

Edit(QueueKey As String) As Integer

Parameters

Parameter	Required	Description
QueueKey	Yes	The database queue key of the record to edit.

Remarks

This method returns one of the following values:

	-1 or 0	An error occurred.
	1	OK button was pressed.
	2	Cancel button was pressed.

Example

The following example launches an editor dialog box for the record "0000012345":

Copy

Edit

1
2
3
4
5
6
7
8
Sub

    Dim iRet
    
    iRet = <SvcEditor>.Edit("0000012345")
     MsgBox iRet
    
End Sub

The following example launches a dialog box for entry "0" of table "COMSTATE."

Copy

Edit

1
2
3
4
5
6
7
8
9
10
Sub

    Dim iKey
    iKey = TrsEditor.Find("COMSTATE", "0")

    Dim iRet
    iRet= TrsEditor.Edit(iKey)
    MsgBox iRet
    
End Sub

Find

The Find method returns the database queue key by table name and table entry for the specified record.

Syntax

Find(TableName As String, TableEntry As String) As String

Parameters

Parameter	Required	Description
TableName	Yes	The name of the table.
TableEntry	Yes	The name of the table entry.

Example

The following example finds the database queue key for entry "0" of table "COMSTATE."

Copy

Find

1
2
3
4
5
6
7
Sub

    Dim iKey
    iKey = TrsEditor.Find("COMSTATE", "0")
    MsgBox iKey

End Sub

New

The New method launches a New Table Entry dialog box.

Syntax

New() As Integer

Remarks

This method returns one of the following values:

	-1 or 0	An error occurred.
	1	OK button was pressed.
	2	Cancel button was pressed.

Example

The following example launches the specified editor dialog box:

Copy

New

1
2
3
4
5
6
7
8
Sub

    Dim iRet
    iRet = <SvcEditor>.New
 
    MsgBox iRet
    
End Sub

View

The View method launches a Properties dialog box for the specified record.

Syntax

View(Key As String, EditEnabled As Boolean) As Integer

Parameters

Parameter	Required	Description
Key	Yes	The database key (DbKey) of the record to view/edit.
EditEnabled	Yes	Set this parameter to true to enable editing of a record.

Remarks

This method returns one of the following values:

	-1 or 0	An error occurred.
	1	OK button was pressed.
	2	Cancel button was pressed.

Example

The following example launches the specified editor dialog box for the record "0000012345":

Copy

View

1
2
3
4
5
6
7
Sub

    Dim iRet
    iRet = <SvcEditor>.View("0000012345", True)
    MsgBox iRet

End Sub